Entity Dimension

The Entity Dimension is different from all others. In a multi-Cube application, the Entity Dimension links everything together.

General Member Properties

These properties are standard across all Dimensions. 

Dimension Type

This indicates what Dimension is currently being used (e.g., Entity).

Dimension

This indicates the Dimension name (e.g., Houston).

Member Dimension

The Dimension to which it is a Member (e.g., HoustonEntity Dimension).

Name

The name of the Member in the Dimension (e.g. Houston Heights).

Default Description

A description of the Member in the Dimension. Refer to Report Alias descriptions for Members.

Security

Display Member Group

This group can see that this Entity exists within a list of Entities.

Read Data Group

This group can see data from this Entity.

Read Data Group 2

This is a second group that can see data from this Entity. It is used for additional security granularity

Read and Write Data Group

This group can see data from this Entity and make changes to it.

Read and Write Data Group 2

This is a second group that can see data from this Entity and make changes to it. It is used for additional security granularity.

NOTE: Click and begin typing the name of the Security Group in the blank field. As the first few letters are typed, the Groups are filtered making it easier to find and select the desired Group.  Once the Group is selected, select CTRL and Double Click. This will enter the correct name into the appropriate field.

Use Cube Data Access Security

If set to True, Cube Data Access Security will be applied from the Cube level down to this Entity, if set to False, Cube Data Access Security will not be applied.

Cube Data Cell Access Categories/Cube Conditional Input Categories/
Cube Data Management Access Categories

Category is used to specify an optional name for a group of Cube Data Access Items. Multiple items can use the same Category name. A comma separated list of Category names can be specified in Entity Properties in the Dimension Library when the data cell security for an Entity should use only a subset of the Cube Data Access Items. 

The settings for these are used to specify a comma separated list of category names that will be processed for the Entity. If these settings are left empty, then all categories will be used in the corresponding settings on the Data Access tab of the Cube Administration page. See Data Access under Cubes for more details.

Settings

Currency

The local currency of a particular Entity.

Is Consolidated

If set to True, the data from this Entity’s children is consolidated (i.e., this Entity will equal the total of its children). 

If set to False, the data will not be consolidated.  The use case to set the Is Consolidated setting to False is to use the Parent Entity strictly for grouping purposes. Also, by setting Is Consolidated to False helps with consolidation performance times because the consolidation will not be performed at the Parent Entity. 

Is IC Entity

If set to True, this will make the Entity an Intercompany Entity. An Entity cannot post intercompany transactions to intercompany accounts if this option is True. This is only required for Base Entities where the intercompany intersections roll up and eliminate. If set to False, this will not be an Intercompany Entity.

Vary by Cube Type

Constraints are Members with a restriction to only specific Members for an Entity or an Account. There can be different settings for each Cube Type because Dimensions can belong to multiple Cubes.

Flow Constraint    

This is the Flow Dimension constraint. This Entity can only use the Members with this child or Member under a selected Parent Member.  

IC Constraint    

This is the Intercompany Dimension constraint. This Entity can only use the Members with this child or Member under a selected Parent Member. Setting Entity constraints will define the data intersection as a green no input cells.

IC Member Filter

This is an additional way to limit intercompany partners of a particular Entity. The IC Member Filter can make a list and the Entity can only have intercompany transactions with this list of partners, and those lists of partners are the only ones that can have a transaction with this Entity.  This provides additional protection to the intercompany transaction.

UD1 Constraint…UD8 Constraint     

This is the User Defined constraint. This Entity can only use the Members with this child or Members under the selected Parent Member.

UD1 Default...UD8 Default

A default Membership for this particular Entity can be defined to a User Defined Dimension such as Region. For example, this Entity falls in the U.S. Region and every import, form edit, and journal entry should classify this Entity as being part of the U.S. Region. The Entity never has to explicitly map to the Region.  When data is loaded by the Staging Engine, it is directed to the EntityDefault Member and the User Defined setting here will be applied automatically. This can have a negative impact on the consolidation if not used in a User Defined Dimension with a limited number of Members.

Vary by Scenario Type

Sibling Consolidation Pass

This is typically used for Holding Companies related to Equity Pickup calculations. Specify Pass 2 or greater if calculated data for this Entity is based on calculated data from other sibling Entities during a consolidation. It allows this Entity to be consolidated and calculated after other sibling Entities have been consolidated and calculated. The default behavior for all Entities is either Pass 1 or (Use Default) (both settings do the same thing) which effectively cause all sibling Entities to be consolidated (if they have Child Entities) and calculated at the same time or in an indeterminate order.

Sibling Repeat Calculation Pass

This is typically used for Circular Ownership related to Equity Pickup calculations. Specify Pass 1 or greater to repeat the calculation of this Entity’s Local Consolidation Member. Repeat Calculation Passes occur after all sibling Entities have been consolidated and calculated. Repeat calculations are used when calculated data for two Entities rely on each other’s calculated data. The default behavior for all Entities is (Use Default) which will not use a repeat calculation.

Auto Translation Currencies

This is typically used for an Equity Pickup calculation when an Entity needs to be translated to a sibling Holding Company’s local currency during a consolidation. Enter a comma separated list of currencies. The default behavior is to translate only to the parent Entity’s local currency during a consolidation. 

See Equity Pickup in About the Financial Model for more details on this feature.

Vary by Scenario Type and Time

During the course of normal business, Entities can have different attributes based on Scenario and Time. There are default settings applied from the first time period in the application until there is a change, and there are settings that vary by Scenario Type.  The time display for any time varying properties uses the Standard Time Dimension Profile.

In Use    

If set to True, the Entity is in use, if set to False, this can turn off the ability to use an Entity based on Time. This keeps historical data available. This is designed to be used when an Entity becomes inactive or is sold. Once an Entity is no longer in use, it will be ignored during consolidation and all intersections including this Entity will be invalid. 

Allow Adjustments   

If set to True (default), the Journals Module is enabled for the Entity to enter adjustments to the AdjInput Origin member. When set to False, the Journals Module is disabled for the Entity. However, when False, adjustment to the AdjInput Origin member is still allowed on Accounts having the Account Adjustment Type of “Data Entry” which is used in designs where adjustments are performed using Form data entry rather than the Journals Module. To prevent input to AdjInput on Accounts set as “Data Entry” Adjustment Type, NoInput Rules or Data Cell Conditional security can be used. This setting can be applied as True/False a default or it can vary by Scenario Type and/or Time. 

Allow Adjustments From Children

This setting is applied on parent level Entities to allow the direct child Entities to post journal adjustments using the Consolidation dimension members OwnerPostAdj and OwnerPreAdj. If set to True (default), adjustments from the direct child Entities to OwnerPostAdj and OwnerPreAdj is allowed. This setting can be applied as True/False a default or it can vary by Scenario Type and/or Time. 

Text1…Text8 

This is open for custom attributes used for multiple purposes such as Business Rules, Member Filters or Transformation Rules. The value can be changed in the tag over time as the business changes or by Scenario Type.

General Relationship Properties

While Dimensions, like Accounts or Flow, contain Members which can be inherited and extended through Extensible Dimensionality ®, Entities are referenced across Entity Dimensions. This means that a reference of an Entity, either within the same Dimension or another, can be created. This is done with the Add Relationship for Selected Member option within the Entity Dimension. In addition, this icon can be used when a Member must be moved out of its current hierarchy and inserted into another one.

These Settings are standard across all Dimensions.

Dimension Type

This indicates what Dimension is currently being used. (e.g., Entity)

Dimension

This indicates the name of the Dimension.

Parent Member Dimension

This displays the name of the Parent Member. This may be blank if it is at the root level. (e.g., NA Clubs, Clubs, etc.)

Member Dimension

This displays the name of the Member. (e.g., CorpAccounts, Scenarios, CorpEntities, etc.)

Parent Member Name

This displays the direct Parent to the Member. In some cases, this may display Root if it is the first branch.

Member Name

This displays the name of the Member as it was defined. (e.g., Actual, Budget, Flash, etc.)

Position within Parent

When a new Member is created, it is added to the bottom of the list of its siblings. Use the Position property to move the Member amongst its siblings. The position will only allow movement in the current tree level. This setting cannot move out of the current hierarchy.

Position

Retain Current Position

Before Sibling Member

After Sibling Member

First Sibling

Last Sibling

Sibling Member
This will show a list of all the siblings in the current hierarchy available to move based on the setting in the Position field.

Default Parent

Parent Sort Order

This setting is used to determine a default Parent when evaluating Member lists (e.g., in Cube Views). If a Parent is not explicitly specified, the Entity’s Parent with the lowest sort order is used.

Vary by Scenario Type and Time

Percent Consolidation  

Define the percentage of the Entity to be consolidated. This setting can also be used to reduce a Member’s value by using a -100 value.

Percent Ownership

This is an ownership setting that can be used by Business Rules if need be. By itself, the setting has no effect on the consolidation.

Ownership Type

This is an ownership setting that can be used by Business Rules if need be. By itself, the setting has no effect on the consolidation.

Full Consolidation

Normal setting for Entities that fully consolidate into a Parent.

Holding

This is used to designate the Parent/Child relationship as a holding company situation.

Equity 

This is used to help Business Rules determine the value to increase the equity method of Accounting for an investment.

Non-Controlling Interest

This is used for Business Rules to determine the minority interest portion of an Entity into the consolidation.

Custom 1…Custom 5  

Open for custom use in Business Rules.

Text 1-8

Use to define custom attributes to modify aspects of business rule, transformation rule and member filter capabilities. These custom attributes act as variable placeholders, activated at run-time to customize views of, or ways to interact with, data. You can change these values by scenario type or to suit evolving business needs.

Dimension Properties Tab

These properties are standard across all Dimensions. 

Dimension Type

Identifies the Dimension it currently is such as Account…UD8.

Name

The current name of the Dimension

Description

The current description of the Dimension

Access Group

This security group has access to the Dimension

Maintenance Group

This security group has access and can make changes to the Dimension.

Source Type

Standard

Normal metadata Member must match a Cube.

Business Rule

Connects to a Business Rule so that a set of Members does not have to match a Cube.

XBRL

Connects to an XBRL taxonomy.

Source Path

Enter the Business Rule name or the full File System Path for the XBRL Taxonomy’s Link Definition File.
‘Internal/XBRL/Taxonomies/EntryPoints/….’

Name Value Pairs (e.g., Param1=Value1,…)

Enter a comma-separated list of name-value pairs if the Source Type is a Business Rule or XBRL.